Summary

During my internship at UPS, I worked with the Business Architecture team to improve how technology governance data was understood and managed. I focused on making data-quality issues within the Product & Platform Operating Model (PPOM) easier to find, understand, and address.

Objective

The goal was to reduce the effort required to identify gaps across thousands of datasets across the PPOM. Rather than manually searching through large amounts of data, I wanted to create a way for the team to quickly understand what was missing and where attention was needed.

Solution

I designed and developed an interactive Power BI dashboard that turns 2,000+ records into a searchable, actionable view. It allows users to:

• Identify Products & Platforms that do not have product or application mappings
• Compare mapped applications/products against orphaned or unmapped applications/products
• Identify missing ownership information, including TPLL and SED assignments
• Drill down from high-level metrics to the specific products or platforms requiring attention
• Use the results to work directly with business contacts and product owners to close data gaps

I turned a difficult-to-spot data governance problem into a visual workflow for finding, understanding, and addressing gaps in technology ownership and application mapping.